SUMMARY

• Confidential is a SQL Reports and Software development consultant. In addition to the concrete Software Engineering degrees from University of Texas and University Of Houston he has altogether 9 years of experience in IT Systems with 6+years’ experience in enterprise level SQL / Reports /Software development.
• He possess experience in being independently responsible for object oriented system design, development, testing and documentation in a product development environment. Has significant experience in coordination of work, status updates and decision - making processes with customers and teams in multi-site engagements.
• Excellent knowledge of Reporting Tools SSRS/Crystal Reports/ JReport/Business Objects
• Worked extensively on RDBMS like MS-SQL Server 2005, 2008 Oracle 8i/9i/10g, DB2
• Excellent BI knowledge ETL - SSIS, SSAS packages.
• Significant experience in ORM tools like Hibernate2.0, and frameworks like .NET 4.0/4.5, MVC, Struts
• Good working Knowledge of, C#, VB6, and UNIX/Linux (Red Hat)
• Good knowledge of web services, RPC, WSDL,SOAP
• Expertise in technologies including Java, JSP, Servlets, JDBC, XML, JavaScript.
• Front end development with HTML, CSS, JSP, Javascript
• Experience in UML, Rational Unified Process (RUP) and Agile development Methodology
• Excellent understanding of source control and sub versioning like clear case, clear quest, star team, SVN
• Good Experience in implementing J2EE based enterprise web services solutions
• Rich experience with application servers like IIS 7, BEA Web Logic 8.1/9.2 IBM’s Websphere 6.0, JBOSS 4.x, TOMCAT 4.0
• Experience with ANT 1.6 scripts to ease deployment to Application Servers
• Experience of IDE like Visual Studio, Rational Software Architect (RSA /RAD), Eclipse,Jbuilder
• Well experienced in JUnit / Nunit and Log4j for l testing environment
• Involved in product development and project software development lifecycles.
• Experience in interacting with clients, collection of requirement specifications and performing requirement analysis and design.
• Clear understanding of design patterns and extensive use of it.
• Good Telecommunication experience and FOIP (Fax Over Internet Protocol)
• Good team player with excellent interpersonal and communication skills.

TECHNICAL SKILLS

Reporting Tools: SSRS Report Builder 3.0,BIDS, VS 2008/2010, Jreport 8.1,Business Object 6.5, Crystal Reports.

Data Extraction / BI: ETL - SSIS packages, SSAS cubes

RDBMS: MS SQL server 2005/2008/ 2008 R2, MySQL, DB2 7.2,Oracle 8iLanguages & API: C#,VB6, JDBC, J2EE, Java Beans

IDE: Visual Studio 2008/2010/2012, Eclipse, RSA

Application/Web Servers: IIS 4.0..7.5, IBM Websphere, JBOSS, BEA Weblogic Server,Tomcat 4.0

Server Technologies: J2EE, Servlets, JSP, XML, ASP, CGI

O/R Frameworks: Hibernate 2.0

Java/J2EE Application Frameworks: Struts MVC, EJB 3.0

Operating Systems: Win32, UNIX (Red Hat Linux)

Object Modeling/Tools: UML, Rational Rose, Enterprise Architect, SVNRational Software Architect, CVS, ClearCase, ClearQuest, Star TeamTesting framework: Junit, Nunit

Client Scripting: Javascript, VBscript

UML Tools: MS Visio, Rational Enterprise

Batch Scripting: Ant

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Sr. Reports Developer / Software Developer

Responsibilities:

• Lead and assist team in Developing the architecture according to company requirement for report access folders within SSRS.
• Creating different and complex reports - scorecard, Sparkline, charts, automated, parameterized, click through, sub reports, drill down, maps, reports and subscriptions.
• Involved in writing the stored procedures and free hand SQL queries.
• Writing SSIS packages in support of OLAP, for report data source.
• Hooked up the reports via URL, implemented security / administration/ architecture.
• Worked extensively with the major functionality of SSRS like Breaks, sections, Group values, Sorts, List of values, Pre-defined conditions, Calculations and Ranking.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in SSRS.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Supported and enhanced existing reports and create new ones as per requirement

Environment: Visual Studio 2010 / 2008,C# .NET 4.0, JSPs,JSP tags, CSS, XML, Webservices(SOAP),SSRS, SQL Server 2008/2008R2, SSIS/SSRS, TFS 2010

Sr. Reports Developer /Software Developer

Confidential

Responsibilities:

• Lead the transition team for conversion of reports from BO to Jreport
• Lead and assisted the team with migration of Reporting platform, Jreport to SSRS
• Developed and designed front-end using HTML, JavaScript, CSS, and JSP Pages,
• Involved in writing the stored procedures and free hand SQL queries.
• Writing SSIS packages in support of OLAP, for report data source.
• Implemented each report as a controller and added to the existing STRUTS MVC framework
• Created a trusted security layer code between application and report server.
• Creating different and complex reports - automated, parameterized, click through, sub reports, drill down, maps, reports and subscriptions.
• Developed JavaScript interaction for presentation layer.
• Hooked up the reports via URL, implemented security / administration/ architecture.
• Worked extensively with the major functionality of SSRS like Breaks, sections, Group values, Sorts, List of values, Pre-defined conditions, Calculations and Ranking.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in SSRS.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Created and integrated complex report for the Legacy language Smalltalk IDE
• Supported and enhanced existing reports and create new ones as per requirement

Environment: Visual Studio 2010, SQL Server 2005/2008/2008R2, SSIS/SSRS, Java2 (JDK 1.5), J2EE, EJBs, JSPs,JSP tags,DHTML, CSS, Struts MVC, Hibernate, EJB 3.0 Servlets,Eclipse, XML, Webservices(SOAP), JReport 8.1, Business Objects 6.5,SSRS, Report Builder 3.0, BIDS,, Footprints, Remedy, SVN, Star team, Jboss, Tidal, Smalltalk IDE

Confidential

Responsibilities:

• Installed and configured SSRS 2008 server for optimal performance
• Developed the architecture according to company requirement for report access folders within SSRS.
• Developed and designed front-end using .NET and C#,
• Involved in writing the stored procedures and free hand SQL queries.
• Customized reports with expressions and aggregate functions
• Restricted report data using parameters and filter
• Developed reports with multiple data regions
• Improved performance with cached report instances and snapshots

Environment: Visual Studio 2010,C# .NET 4.0, JSPs,JSP tags, CSS, XML, Webservices(SOAP),SSRS, Report Builder 3.0, BIDS, Visual Studio 2010, SQL Server 2005/2008/2008R2, SSIS/SSRS, Footprints, Remedy, SVN, Star team

Confidential

ER Handbook

Responsibilities:

• Installed and configured SSRS 2008 for optimal performance
• Developed and designed front-end using HTML, JavaScript, CSS, and JSP Pages,
• Involved in writing the stored procedures and free hand SQL queries.
• Developed reports with the major functionality of SSRS like Breaks, sections, Group values, Sorts, List of values, Pre-defined conditions, Calculations and Ranking.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in SSRS.
• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate to Technical specifications for Emerging New Reports.
• Built SSAS cubes where user could design their own reports.
• Provided user with integrated SharePoint/ssrs interface.
• Used SharePoint as repository.
• Configured the data flow task and its transformations
• Debugged SSIS packages and its scripts
• Set up user access in both SSRS and SharePoint according to groups.
• Created shared data sources and web parts to share against different groups.
• Created scheduled and subscribed reports.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Built Dashboard reports for graphical presentation
• Developed standard, cross-tab, On Demand and Drill-down Reports
• Developed reports with the major functionality of SSRS like Breaks, sections, Group values, Sorts, List of values, Pre-defined conditions, Calculations and Ranking.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in SSRS.
• Added interactive with drill-down, drill-through, hyperlinks, and bookmarks
• Created reports using table, matrix, chart, list, indicator, map, and gauge data regions
• Subscribed to reports using standard and data-driven subscriptions
• Delivered reports using e-mail and file shares

Environment: VS .NET, JSPs,JSP tags, CSS, XML, SSRS, Report Builder 3.0, BIDS, Sharepoint 2010, Visual Studio 2010, SQL Server 2008/2008R2, SSIS/SSAS/SSRS, Footprints,Remedy, SVN

Confidential, Sarasota, Fl

Reports Developer / Software Developer

Responsibilities:

• Implemented each report as a controller and added to the existing SPRING MVC framework
• Each controller makes call to the Data Access Object, Mapped the classes to the DB2 tables
• Optimized the existing SQL queries and for better performance.
• Added a LOB and reflected the change in the existing code and framework.
• Built XSD needed for the final XML generation for the reports.
• Worked on building JREPORT templates and catalogue.
• Conversion of reports from Crystal VB to Jreport
• Creating reports from stored procedures, freehand sql, tables, views..
• Made the JREPORT templates adapt to different sources, JDBC, XML,
• Involved in writing the ANT scripts for automating the process of building, testing and deploying the system.
• Writing XML build file to automation of deployment process Ant build system Involved in build and release management for the system.
• Unit and integrated testing through JUnit.
• .Developed Coding Style Sheets (CSS) and JavaScript’s for validations.
• Developed applications and wrote scripts as and when needed.
• Supervised / Managed as the head of Fax2fax Dept, Monitored FOIP operations in NT.
• Ensured the proper running of SMTP and Proxy servers in Linux Environment.
• Upgraded Linux and NT softwares for the servers, Troubleshooted DSL modems.